Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RevisionNumber (PK) | The version number used to track modifications to the CustomerRewardProgramTermsAndConditions over time. | AI_RVSN_NMB | Number | integer | |
CustomerAccountContractNarrative | Narrative text for the CustomerRewardLegalTermsAndConditions. | NA_CT_ACNT_CNTRT_NRTV | DescriptionNarrative | varchar(4000) | |
EffectiveDate | Date this program legal terms and provisions document revision is in force. | DC_EF_DT | EffectiveDate | date | |
ExpirationDate | Date this program legal terms and provisions document revision is no longer in force. | DC_EP_DT | ExpirationDate | date | |
StatusCode | Current status of this terms and conditions revision. Retailers need to exercise care in assigning status codes. While a contract may be modified prior versions tied to older customer accounts may remain in force. Retailers need to define an appropriate contract life cycle management strategy as part of implementing this entity. | CD_STS | Code2Status | char(2) | |
MembershipProgramID (FK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerMembershipProgram(CO_CT_MBRSHP_PRGM) |